﻿/****************************************************************************************************
 **        Name: AssemblyInfo
 ** Description: Information on the assembly where an exception occurred.
 ****************************************************************************************************
 ** Revisions
 **  Date        Author               Work Item  Description
 **  ----------  -------------------  ---------  ----------------------------------------------------
 **  11/30/2008  Chad Green             11774    Initial Development
 ****************************************************************************************************/

CREATE TABLE dbo.AssemblyInfo
(
	ID            int           NOT NULL IDENTITY(1,1),
	ExceptionID   char(49)      NOT NULL,
	AssemblyName  nVarChar(MAX) NOT NULL,
	CompanyName   nVarChar(MAX) NOT NULL,
	Copyright     nVarChar(MAX) NOT NULL,
	Description   nVarChar(MAX) NOT NULL,
	DirectoryPath nVarChar(MAX) NOT NULL,
	ProductName   nVarChar(MAX) NOT NULL,
	StackTrace    nVarChar(MAX) NOT NULL,
	Title         nVarChar(MAX) NOT NULL,
	Trademark     nVarChar(MAX) NOT NULL,
	Version       nVarChar(MAX) NOT NULL,
	WorkingSet    bigInt        NOT NULL
)
GO

EXEC sp_addextendedproperty N'MS_Description', N'Information on the assembly where an exception occurred.', 'SCHEMA', N'dbo', 'TABLE', N'AssemblyInfo', NULL, NULL
GO
EXEC sp_addextendedproperty N'MS_Description', N'Identifier of the AssemblyInfo record.', 'SCHEMA', N'dbo', 'TABLE', N'AssemblyInfo', 'COLUMN', N'ID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign Key - Identifier of the associated exception record.', 'SCHEMA', N'dbo', 'TABLE', N'AssemblyInfo', 'COLUMN', N'ExceptionID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The name, without the extention, of the assembly file for the application.', 'SCHEMA', N'dbo', 'TABLE', N'AssemblyInfo', 'COLUMN', N'AssemblyName'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The company name associated with the application.', 'SCHEMA', N'dbo', 'TABLE', N'AssemblyInfo', 'COLUMN', N'CompanyName'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The copyright notice associated with the application.', 'SCHEMA', N'dbo', 'TABLE', N'AssemblyInfo', 'COLUMN', N'Copyright'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The description associated with the application.', 'SCHEMA', N'dbo', 'TABLE', N'AssemblyInfo', 'COLUMN', N'Description'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The directory where the application is stored.', 'SCHEMA', N'dbo', 'TABLE', N'AssemblyInfo', 'COLUMN', N'DirectoryPath'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The product name associated with the application.', 'SCHEMA', N'dbo', 'TABLE', N'AssemblyInfo', 'COLUMN', N'ProductName'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The stack-trace information at the time of the exception.', 'SCHEMA', N'dbo', 'TABLE', N'AssemblyInfo', 'COLUMN', N'StackTrace'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The title associated with the application.', 'SCHEMA', N'dbo', 'TABLE', N'AssemblyInfo', 'COLUMN', N'Title'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The trademark notice associated withthe application.', 'SCHEMA', N'dbo', 'TABLE', N'AssemblyInfo', 'COLUMN', N'Trademark'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The version number of the application.', 'SCHEMA', N'dbo', 'TABLE', N'AssemblyInfo', 'COLUMN', N'Version'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The amount of physical memory mapped to the process context.', 'SCHEMA', N'dbo', 'TABLE', N'AssemblyInfo', 'COLUMN', N'WorkingSet'
GO